﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ZhimeiSoft.CharmManager.Server.DAL
{
    public class ScheduleDAL_Const
    {
        public static readonly string SQL_INSERT_SCHEDULE = @"INSERT INTO SCHEDULE (SALONID ,SCHEDULENAME ,SCHEDULETIME ,SYSTIME ,STATE ,SPLANSTARTTIME ,SPLANENDTIME,
            SPLANTIMESTATE ,SPLANMEMO ,SCHEDULETYPE ,SPLANEMPLOYEE)   
            VALUES (@SALONID ,@SCHEDULENAME ,@SCHEDULETIME ,@SYSTIME ,@STATE ,@SPLANSTARTTIME ,@SPLANENDTIME ,@SPLANTIMESTATE ,@SPLANMEMO ,@SCHEDULETYPE ,@SPLANEMPLOYEE)";

        public static readonly string SQL_DELETE_SCHEDULE = @"DELETE FROM SCHEDULE WHERE SCHEDUEID = @SCHEDUEID";

        public static readonly string SQL_UPDATE_SCHEDULE = @"UPDATE SCHEDULE SET SALONID = @SALONID_NEW,SCHEDULENAME = @SCHEDULENAME_NEW,SCHEDULETIME = @SCHEDULETIME_NEW,SYSTIME = @SYSTIME_NEW,STATE = @STATE_NEW
                        ,SPLANSTARTTIME = @SPLANSTARTTIME_NEW,SPLANENDTIME = @SPLANENDTIME_NEW,SPLANTIMESTATE = @SPLANTIMESTATE_NEW,SPLANMEMO = @SPLANMEMO_NEW,SCHEDULETYPE = @SCHEDULETYPE_NEW,SPLANEMPLOYEE = @SPLANEMPLOYEE_NEW
                    WHERE SCHEDUEID = @SCHEDUEID ";

        public static readonly string SQL_QUERY_SCHEDULE_STATE = @"SELECT SCHEDUEID ,SALONID ,SCHEDULENAME ,SCHEDULETIME ,SYSTIME ,STATE ,SPLANSTARTTIME ,SPLANENDTIME
                    ,SPLANTIMESTATE ,SPLANMEMO ,SCHEDULETYPE ,SPLANEMPLOYEE  FROM SCHEDULE WHERE STATE = @STATE ";

    }
}
